Enhancement of Oracle‘s Indexing Capabilities through GiST-implemented Access Methods
نویسندگان
چکیده
Indexing is one of the most important tool for efficiency enhancement, available in DMBS today. The necessity of speeding up queries in very large database systems is unquestioned. The use of new-fashioned technologies and applications such as Multimedia, E-Commerce or Geographic Information Systems in combination with commercial database systems show the shortness of current indexing mechanism. This technical report introduces a possible way out of this dilemma. We make use of Oracle’s Data Cartridge technology in combination with the GiST-framework, so that we are able to index any kind of data with any kind of balanced index trees.
منابع مشابه
High-Performance Extensible Indexing
Today’s object-relational DBMSs (ORDBMSs) are designed to support novel application domains by providing an extensible architecture, supplemented by domain-specific database extensions supplied by external vendors. An important aspect of ORDBMSs is support for extensible indexing, which allows the core database server to be extended with external access methods (AMs). This paper describes a new...
متن کاملOraGiST - How to Make User-Defined Indexing Become Usable and Useful
In this article we present a concept for simplification of user-defined indexing for user-defined data types in object-relational database systems. The concept is based on a detailed analysis of user-defined indexing in ORDBS on one hand, and features of generalized search trees (GiST) as an extensible indexing framework on the other hand. It defines a minimal interface to be implemented in ord...
متن کاملAdvanced Indexing Techniques for Achieving Concurrency in Multidimensional Data Sets
In multidimensional datasets concurrent accesses to data via indexing structures introduce the problem protecting ranges specified in the retrieval from phantom insertions and deletions. This paper proposes a novel approach for concurrency in multidimensional datasets using Advanced Indexing Technique like generalized search tree, R tree and its variants, constitutes an efficient and sound conc...
متن کاملCreating a Customized Access Method for Blobworld
We present the design and analysis of a customized access method for the content-based image retrieval system, Blobworld. Using the amdb access method analysis tool, we analyze three existing multidimensional access methods that support nearest neighbor search in the context of the Blobworld application. Based on this analysis, we propose several variants of the R-tree, tailored to address the ...
متن کاملMr Imaging Features of Gastrointestinal Stromal Tumor (gist) of the Gastrointestinal (gi) Tract
PURPOSE: The radiologic findings of GIST have been well described in the radiology literature. However, there were few reports that had reported the MR imaging features of GIST. Therefore, the aim of this study is to describe the MR imaging features of GIST of the gastrointestinal (GI) tract. METHODS: We retrospectively reviewed the pathologic and medical records from January 2007 to September ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2002